Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks

Parameters

Parameter	Type	Size
@Beginning_Date	datetime	8
@Ending_Date	datetime	8

Source Code

create procedure "Sales by Year" 
	@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal, DATENAME(yy,ShippedDate) AS Year
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date